package com.bw.mapper;

import com.bw.bean.KeyWord;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface DorisMapper {

    @Select("select sum(original_amount) from dws_trade_sku_order_window where cur_date = #{date}")
    String getMv(String date);

    @Select("select keyword,sum(keyword_count) from dws_traffic_source_keyword_page_view_window where cur_date = #{date} group by keyword")
    List<KeyWord> getkeyWord(String date);
}
